Overview: Sink block

Export any dataset in your data recipe to a sink block, including locked datasets. This operation sinks data in a defined format, determined by the type of sink block selected. The sink blocks available for this operation include the Text -, Optimized Database-, and Tabular Database sink. Using this operation, data can be saved and used in other applications.

Properties

Category:	Export
Performance risk:	Potential high performance risk. Because this operation uses Sink blocks, it can potentially take longer than other sink operations. The bigger the dataset, the longer this operation is going to take, as the block needs to execute for each row in the dataset.
Knowledge required:	Working knowledge of the software.

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	N/A
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	Yes
Does it modify the current dataset in any way?	N/A

Requirements

This operation needs a dataset that contains at least one double, integer, string or timestamp field.

Results

An exported dataset, the format of which is determined by the sink you selected.
The fields selected will be exported with the selected sink block.

Common errors

Error

Action required

Block that is not runnable.

This happens when you either don’t configure the file name/data source or use an invalid file/source configuration, when configuring the sink block.

After configuring the sink block, the next page displayed will be a runnability page stating the error.

To avoid it: Make sure you configure the sink correctly.

To correct it: Click [Previous] and correct the error.